Defining the connection parameters

This section describes how to use a Microsoft Azure Synapse Analytics database as a data warehouse in a Qlik Compose project.

To define Microsoft Azure Synapse Analytics as a data warehouse:

1. Open your project and click Manage in the bottom left of the Databases panel.

   The Manage Databases window opens.

2. Click the New toolbar button or click the Add new database link in the middle of the window.

   The New Data Warehouse dialog box opens.

3. From the Type drop-down list, select the desired data warehouse.

4. Enter the information as described below:

   • Connection input mode: Select Standard or Advanced.

     If you selected Standard connection input mode, specify the following:

     • Server Name: The name of the Microsoft Azure Synapse Analytics server you are using.
     • Port: The port number for the Microsoft Azure Synapse Analytics.
     • User Name: The user name of a registered Microsoft Azure Synapse Analytics user.
     • Password: The password for the user entered in the User name field.

     If you selected Advanced connection input mode, specify the following:

     Information noteIf you want to use an Active Directory password (authentication=ActiveDirectoryPassword), you first need to download the msal4j.jar file and copy it to {COMPOSE-INSTALL-DIR}\java\jdbc.
     • Password: The password required for connecting to the Microsoft Azure Synapse Analytics database.
     • ODBC Connection String: The string of parameters required to connect to the Microsoft Azure SQL ODBC Driver.
     • JDBC Connection String: The string of parameters required to connect to the Microsoft Azure SQL JDBC Driver.
     Information noteCompose will concatenate the database name to the ODBC/JDBC connection string.
   • Warehouse Properties: Specify the following:
     • Database Name: The name of the target database. This must be the same as the target endpoint defined in the Qlik Replicate task. For more information, see Defining a Qlik Replicate task.
     • Data Warehouse Schema: The schema in which to create the data warehouse tables.
     • Data Mart Schema: The schema in which to create the data mart.
   • More Options: Click to see or hide the following advanced options:

     • Additional JDBC Parameters: Any additional parameters you need to add to the default JDBC connection string. The parameters should be separated by a semi-colon.

       Format:PARAM1=VALUE1;PARAM2=VALUE2

     • Additional ODBC Parameters: Any additional parameters you need to add to the default ODBC connection string. The parameters should be separated by a semi-colon.

       Format:PARAM1=VALUE1;PARAM2=VALUE2

5. Click Test Connection to verify that Compose is able to establish a connection with the specified data warehouse.

6. Click OK to save your settings.

   The database is added to the list on the left side of the Manage Databases window.